UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lXSLYMEPSpaZkI2TohbReVwoNowoQh/uCQ/z3RReZbI='
WHERE
key_id = '1406c4c76cd98f5333abfba565522ca5b46fdd4a9ae4c2e6e556cde9c166873a'
AND (
token = 'lXSLYMEPSpaZkI2TohbReVwoNowoQh/uCQ/z3RReZbI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)