UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KSeXm6RuxCalm+c9fUMhDVQDi/KvDrp6grFVgUgJJHk='
WHERE
key_id = 'e56bd99f8846e9b07462e56f83a259f4174b170389d3851abc8e44819bac99fc'
AND (
token = 'KSeXm6RuxCalm+c9fUMhDVQDi/KvDrp6grFVgUgJJHk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)