UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BZdy/g+o5pQd85m57f3pIOaRsTcAF9CcHjjh/67HUgg='
WHERE
key_id = 'a740c49282e8e9a1b2f349b83ea1a0dbbc194f2fe587c94583f390e7b804ad8f'
AND (
token = 'BZdy/g+o5pQd85m57f3pIOaRsTcAF9CcHjjh/67HUgg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)