UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bmhxkPySUip9eBxAKJT3slwN062Y8J89YvIFBNqwfKk='
WHERE
key_id = '9f5528ab7fb5d8bf6959be0b1870239213b380cd768af541acb4d6d96055fa6e'
AND (
token = 'bmhxkPySUip9eBxAKJT3slwN062Y8J89YvIFBNqwfKk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)