UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7hjInhzaA6w2iS3vMJnGvX7aWxv6yKq8eTNTvZ5nlDg='
WHERE
key_id = 'f5bfcf1411b2c8eb8a4b85d96273d2989dc9e0b2759959da13333bfa6ab1643a'
AND (
token = '7hjInhzaA6w2iS3vMJnGvX7aWxv6yKq8eTNTvZ5nlDg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)