UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'er3CBCJtBf7Goqd8suxEEkdny6xAUczwvVfirrUmbB8='
WHERE
key_id = '5f92a1d20baa30dfc8bb349f9c6f26554af12fd41f5ba8a16be362d9c6b3596b'
AND (
token = 'er3CBCJtBf7Goqd8suxEEkdny6xAUczwvVfirrUmbB8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)