UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fnZZ/q+XK7ArKTlbXb9w0jju5r/CKFL5+geRAduzzYw='
WHERE
key_id = 'ad6bd0bf503bf44d9281ad874a05756026ff5ad10e75eae6f03cd30907406821'
AND (
token = 'fnZZ/q+XK7ArKTlbXb9w0jju5r/CKFL5+geRAduzzYw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)