UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bZB5kbrCk/GXd/FWSNG9fz30vxS6bt1ZZUWOlXucIE0='
WHERE
key_id = '27e20e09716ebfd66b5c1a8794d24f565dfaa8a9cc96dc2ba57842467c6b9773'
AND (
token = 'bZB5kbrCk/GXd/FWSNG9fz30vxS6bt1ZZUWOlXucIE0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)