UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zx4aAw5udfr6K2G3Um4pCRfQHh5ANl6IsMbUnXJ08WE='
WHERE
key_id = '367d421572f2c09faac7e54b8768df7c7428fee79d9495dea765be32534d68ae'
AND (
token = 'zx4aAw5udfr6K2G3Um4pCRfQHh5ANl6IsMbUnXJ08WE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)