UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'afEgXIo/FooG5WPAyniYtCm1686Z+ZENQzPKc1PJRKc='
WHERE
key_id = '685fa77c14e45909d621a4bf23537a66c0161d3cb0a7cca931591f8105074be2'
AND (
token = 'afEgXIo/FooG5WPAyniYtCm1686Z+ZENQzPKc1PJRKc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)