UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yN+gmfj7p9zRBp6+RClQIC2g+fzgDo3etPVB2kmGw3M='
WHERE
key_id = '485484bfafec83f3e611c8f073daefa8938ed42878c6d37903673a9815acd46f'
AND (
token = 'yN+gmfj7p9zRBp6+RClQIC2g+fzgDo3etPVB2kmGw3M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)