UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0Bl4WBC1Tya5P0MjywzCdS+qg/jADxhgNRGW4edefGk='
WHERE
key_id = '1eaf9e5b80b1822d706c3828b9a6778445bd650a7bd1834fd85a2933bc388dd5'
AND (
token = '0Bl4WBC1Tya5P0MjywzCdS+qg/jADxhgNRGW4edefGk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)