UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7m5n0erVKaby+PHsORUZYDUs4/+b1RfJIbjae41Yi7g='
WHERE
key_id = 'a4b2cdb23c2732f178b8e73f05fb6746336b765a25c32dc6bed80b15f4763a5e'
AND (
token = '7m5n0erVKaby+PHsORUZYDUs4/+b1RfJIbjae41Yi7g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)