UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gYK8UdbZHmSpiOffWgiMKD+1JK8IuLpzZbS67W2UpyE='
WHERE
key_id = '7093b7a015b9247c8c7ec3228f75c0484d3f58a91d6ad567ca9e802477024aea'
AND (
token = 'gYK8UdbZHmSpiOffWgiMKD+1JK8IuLpzZbS67W2UpyE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)