UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/8uR5ycywfwwFeIHogq3STKFK3wVIFTavbk+urbisSY='
WHERE
key_id = '7ecef75503b796b7c4e0c1aa556b0829602729b9a9dea1f6226ec220cddcf274'
AND (
token = '/8uR5ycywfwwFeIHogq3STKFK3wVIFTavbk+urbisSY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)