UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7eBDiO/oBFk8N7mBcWQK2WjggQs1SPdDrxY1qRY1w3M='
WHERE
key_id = '58a6d9aac6cc4be79873b6c2ec54a16b3b863979bcba133980441d0376c3b84b'
AND (
token = '7eBDiO/oBFk8N7mBcWQK2WjggQs1SPdDrxY1qRY1w3M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)