UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k5RX4+HyXi5aYOOork1yCqwegnnTBZoh1iDu0h6mklA='
WHERE
key_id = '7eebe02a75f2e24a0b925f775430409b96de92de86832146bf03766a5ea53e2c'
AND (
token = 'k5RX4+HyXi5aYOOork1yCqwegnnTBZoh1iDu0h6mklA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)