UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cCRlpUdoYzWXq2bKZImmcZfP/TERmvgCi8CoObOGXTY='
WHERE
key_id = 'c1b00fe980aa5517654d522126dd0c308336a7596c1413ddf5e49bf340249543'
AND (
token = 'cCRlpUdoYzWXq2bKZImmcZfP/TERmvgCi8CoObOGXTY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)