UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bPqXDE8aTZbfWUZ3ezthLciFN1kCiyWmgyDmd/bdKDo='
WHERE
key_id = '1e25a86ec5c945f0f249ccacfc72467d0ffb547da98a025ea5c0e7d408d8242f'
AND (
token = 'bPqXDE8aTZbfWUZ3ezthLciFN1kCiyWmgyDmd/bdKDo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)