UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XzF/o8Luu3/EnmAgW0ejpG3iowS9qYV0SREO5ZUa3dw='
WHERE
key_id = '7b42a3145676ff7050381df33ffc608ac3bd8ce2c4de451eb552669b606a7894'
AND (
token = 'XzF/o8Luu3/EnmAgW0ejpG3iowS9qYV0SREO5ZUa3dw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)