UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nnLLSRzz7X/KAeMMHfklDnoXcDtX52rUVAacNlVaoes='
WHERE
key_id = '13578ea65834024bff626c49ba5b3f0aee16db161e7b14444e75923408ca8d07'
AND (
token = 'nnLLSRzz7X/KAeMMHfklDnoXcDtX52rUVAacNlVaoes='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)