UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'h6dcfTrKT9FaTatVRO0CY0i851n6zfH38i/RJLyGqbQ='
WHERE
key_id = 'a9bb0bf294b3af52924f06dc30f123a0b9591da1c4046258374143bb0f139ad0'
AND (
token = 'h6dcfTrKT9FaTatVRO0CY0i851n6zfH38i/RJLyGqbQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)