UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BiJ+MXTEG6QaV4mXoUGRcnmH/TsPV/1fY3ch2VXKDj4='
WHERE
key_id = 'e021a034f297543f52871c6a0ffd3f3918cfff988672fec8ff9d1dca8566cf2c'
AND (
token = 'BiJ+MXTEG6QaV4mXoUGRcnmH/TsPV/1fY3ch2VXKDj4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)