UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mIaDFvSbIbvWGevgp7HWZ+9LkiDi8Jg2Jf8GCONEiu0='
WHERE
key_id = 'cb993447587e9fb211a309152876240b90ea28581be0cd3e76891d9cc0aa1ddb'
AND (
token = 'mIaDFvSbIbvWGevgp7HWZ+9LkiDi8Jg2Jf8GCONEiu0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)