UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2Zi7defjxvWFWIyMiCToCN90i8abYB4oz3jL0ixShb0='
WHERE
key_id = 'e6b4a3ca2a6b9ab07fb085594b966f05c2a679047bf5f41612af720274202547'
AND (
token = '2Zi7defjxvWFWIyMiCToCN90i8abYB4oz3jL0ixShb0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)