UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zgeX/cSqO0Cu0xu2dqXfxbmsvGafssDnuUDyMcuUPj4='
WHERE
key_id = '472ac826de622ea814a8ea0d30f862cf847d77a32a522f9ee18a78ba076a19d2'
AND (
token = 'zgeX/cSqO0Cu0xu2dqXfxbmsvGafssDnuUDyMcuUPj4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)