UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NbBGl6vg/iQhhiocuzAJI9dDmEmosDnIEIHSbZXMU4c='
WHERE
key_id = '7bea6193eef3a57c3ad00e3ae6dd6cc1beea35359472f194add93099599a59f2'
AND (
token = 'NbBGl6vg/iQhhiocuzAJI9dDmEmosDnIEIHSbZXMU4c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)