UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9Y+A+u+yEAOQFpsWNDJDmU0QkpQ+T60F2tnvTsR0Puo='
WHERE
key_id = '3c81a54e0f69780e1a23810612996913e5691680513ace4dc6d5797a0164699a'
AND (
token = '9Y+A+u+yEAOQFpsWNDJDmU0QkpQ+T60F2tnvTsR0Puo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)