UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N/p8YFDSAFxYSw/u9G5ciJrRP/MlAeTeJ6TRv/GeN/8='
WHERE
key_id = '46c8e3dd487e80b145ae30df506871500ef44a9933927c5030de9523b5357e32'
AND (
token = 'N/p8YFDSAFxYSw/u9G5ciJrRP/MlAeTeJ6TRv/GeN/8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)