UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QAkz+tt+kgPGEgEfzudaJO5lVT+6WIhbKBLwXa5vNc4='
WHERE
key_id = '458a7912c68d740c2d4f35dd9b8a36e76a60217c07bc57e8ba032728baaf9481'
AND (
token = 'QAkz+tt+kgPGEgEfzudaJO5lVT+6WIhbKBLwXa5vNc4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)