UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vbao/OuBoyhOfZhGlw8aZ0hdWUMlVT14Q7mVPrbBmX4='
WHERE
key_id = 'af2e5e714258a54ad8854ff5d1757dc714300b8c464842cf1cd1a93953dc98f8'
AND (
token = 'vbao/OuBoyhOfZhGlw8aZ0hdWUMlVT14Q7mVPrbBmX4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)