UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Tz15b8a8+AMb30SVWMQkkMNFiAeJe3o+lB0b3s5qH48='
WHERE
key_id = 'e7bf358cc23930ad92755ef6ef516d955bef860b265ce901e56c6eeab8ff2a4d'
AND (
token = 'Tz15b8a8+AMb30SVWMQkkMNFiAeJe3o+lB0b3s5qH48='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)