UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V2riNivdERjBdDCNtb6R5cROa1ikshbduL3/YcqYSUk='
WHERE
key_id = '7b845495cf4057a44fb09b1602373f397a24c73cccd4caede46801f90e98f83b'
AND (
token = 'V2riNivdERjBdDCNtb6R5cROa1ikshbduL3/YcqYSUk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)