UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'emjKMUfBanA19KQs0mP42zwCdlzlZfdNZQeVtMygXCI='
WHERE
key_id = 'd844201ae18076b58dd1951ac97e24c365d465f325967b8b1bf16a763023192a'
AND (
token = 'emjKMUfBanA19KQs0mP42zwCdlzlZfdNZQeVtMygXCI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)